Data

Air Travel Consumer Report Period From June 2003 to October 2020

Airline Delay Causes Database:

Airport delay statistics (Bureau of Transportation Statistics): Dataset obtained from: Dataset link

carrier information:

Airport statistics:

Airport Database:

Dataset obtained from: Aviation Support Tables

airports.csv describes the locations of US airports, with the fields:

This majority of this data comes from the FAA, but a few extra airports (mainly military bases and US protectorates) were collected from other web sources by Ryan Hafen and Hadley Wickham.

Types of Delay

Carrier Delay

Carrier delay is within the control of the air carrier. Examples of occurrences that may determine carrier delay are: aircraft cleaning, aircraft damage, awaiting the arrival of connecting passengers or crew, baggage, bird strike, cargo loading, catering, computer, outage-carrier equipment, crew legality (pilot or attendant rest), damage by hazardous goods, engineering inspection, fueling, handling disabled passengers, late crew, lavatory servicing, maintenance, oversales, potable water servicing, removal of unruly passenger, slow boarding or seating, stowing carry-on baggage, weight and balance delays.

Late Arrival Delay

Arrival delay at an airport due to the late arrival of the same aircraft at a previous airport. The ripple effect of an earlier delay at downstream airports is referred to as delay propagation.

NAS Delay

Delay that is within the control of the National Airspace System (NAS) may include: non-extreme weather conditions, airport operations, heavy traffic volume, air traffic control, etc. Delays that occur after Actual Gate Out are usually attributed to the NAS and are also reported through OPSNET.

Security Delay

Security delay is caused by evacuation of a terminal or concourse, re-boarding of aircraft because of security breach, inoperative screening equipment and/or long lines in excess of 29 minutes at screening areas.

Weather Delay Weather delay is caused by extreme or hazardous weather conditions that are forecasted or manifest themselves on point of departure, enroute, or on point of arrival.

OPSNET Delay Cause

Delays to Instrument Flight Rules (IFR) traffic of 15 minutes or more, experienced by individual flights, which result from the ATC system detaining an aircraft at the gate, short of the runway, on the runway, on a taxiway, and/or in a holding configuration anywhere en route.

Such delays include delays due to weather conditions at airports and en route (Weather), FAA and non-FAA equipment malfunctions (Equipment), the volume of traffic at an airport (Volume), reduction to runway capacity (Runway), and other factors (Others). Flight delays of less than 15 minutes are not reported in OPSNET. ASPM reports the most dominant OPSNET delay cause for any flight with an ASQP Reported NAS Delay.

flight information

Diverted Flight

A diverted flight is one that has been routed from its original arrival destination to a new, typically temporary, arrival destination. The leg of the flight that is routed back to the original arrival destination is called the recovery leg.

When you are viewing flight information for a diverted flight, you will see the diversion leg. The recovery leg will be displayed only if available.

Bureau of Transportation Statistics

airplane-on-world-map.jpg

Air Travel Consumer Report Period From June 2003 to October 2020

Types of Delay

1.Carrier Delay

2.Late Arrival Delay

3.NAS Delay

4.Security Delay Cause

5.Weather Delay Cause

Analysis layer

1.Airline

2.Airport

2.State

we can see that we get infinity for the mean value as we discover that we has zero values

1.Analysis Airline Layer

What is the most carrier agent makeing flights?

What is the most carrier agent makeing delay ?

What is carrier agent make delay more than def avg Delay?

2.Analysis Airports Layer

What is The Most US Airports had Weather Delay?

Map of US Airports shown the most affected with Weather Delay

airport%20distribution%20by%20state%20and%20Weather%20Delay-2.png

What is Most US Airport by LONGITUDE,LATITUDE had Flight Cancelled

What is Most US Airport had Carrier Delay?

Map satellite view of US Airports shown the most affected with Carrier Delay

What%20is%20Most%20US%20Airport%20had%20Carrier%20Delay.png

3.Analysis State Layer

What is The Most US State had Weather Delay?

Map view of Most US State affected by Weather Delay

Florida,California,Texas is the Most US State affected by Weather Delay

What%20is%20The%20Most%20US%20State%20had%20Weather%20Delay-2.png

4. Data Visualization

Project 3.Communicate Data Findings